Forum Discussion
joshua1990
Post Prodigy
Post ProdigySwitch between Currency and Number
Hi all!
I have a report where I would like to put a switch on top as a slicer to switch between currency and units.
For this objective I started with this approach:
SWITCH A =
VAR _Selection ...
joshua1990
Sure,
Here is an example file
ValtteriN
Community Champion
Community Championjoshua1990
Sure,
Here is an example file
joshua1990Post Prodigy
Post ProdigyValtteriN : Thanks a lot for providing this. It seems like the same column is display once in units and once in dollars, right?
But what I need is something the also multiplies the units into a dollar value. I have a column with units, I have a column with the price per unit and then if needed I have a calculated column with the total dollars (units x price)