Hi everyone,
I need some advice.
I have an app to monitor prices from my clients suppliers which has columns for package price and a unit price.
Some suppliers provide a per KG price and others provide a pack price. For example a 10 kilogram bag.
I wanted the user to choose via an enum button which type of price was supplied on the invoice and then based on the submission, Unit OR Pack, it would allow for them to enter the type of price they had on the invoice and calculate the missing price.
So I've hidden the columns using the following show if expressions
Pack Price column - or[UnitPack]="Pack",isnotblank([UnitPrice]))
Unit Price column - or[UnitPack]="Unit",isnotblank([PackPrice]))
I then tried to use the following expressions in the initial value columns
IFS([UnitPack]="Pack",[PackPrice]/[Unit])
IFS([UnitPack]="Unit",[UnitPrice]*[Unit])
I get a circular definition error, I can't work out why. I found something in the community referring to issues with reset on edit, I tried looking for any columns with this switched on but couldn't find any.
Anybody else had this issue and know of a workaround so I can get this function to work?
LinkedIn
Twitter
